EMT Practice Test

1. Question Content...

---

Question1: You are working on a flat file-based planning model. You want to prevent manual data entry for certain data intersections. What options do you have? Note: There are 2 correct Answers to this question.

Question2: You are creating a planning model that is based on SAP BPC, version for SAP BW/4HANA Embedded option. What sources are supported for the SAP Analytics Cloud model?

Question3: What node types can be imported from S/4HANA? Note: There are 3 correct Answers to this question.

Question4: You have created a new SAP Analytics Cloud dimension to be used for SAP S/4HANA master dat a. To import the members, text, and hierarchy data, how many data sources do you need?

Question5: In the pre-delivered planning content, which financial statement version is used to integrate S/4HANA account hierarchies and SAP Analytics Cloud account hierarchies?

Question6: In the visual editor for advanced formulas, which of the following formula options can you select? Note:
There are 2 correct Answers to this question.

Question7: Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

Question8: You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return? Note: There are 2 correct Answers to this question.

Question9: You need to plan with finance data from SAP S/4HANA in SAP Analytics Cloud. To get started, you need to import master data from SAP S/4HANA. You are following the steps recommended by SAP. From which source can you import master data from SAP S/4HANA?

Question10: You have a planning model with the following dimensions: account, product, profit center, date, and version. In a story, which new master data can you add on the fly? Note: There are 2 correct Answers to this question.

Question11: Why would you decide to use an Analytic Application instead of a Story? Note: There are 2 correct Answers to this question.

Question12: What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct Answers to this question.

Question13: What data can be exported from SAP Analytics Cloud to SAP S/4HANA? Note: There are 2 correct Answers to this question.

Question14: When you set up a copy data action, what must you do to allow the user to select the source and target version?

Question15: Which dimension types support the system-generated Person Responsible property? Note: There are 2 correct Answers to this question.

Question16: Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse? Note: There are 2 correct Answers to this question.

Question17: You want to create a copy data action that allows you select the source values and target values for the following dimensions at run time: Version. Account. Time. What do you specify for each of these dimensions?

Question18: What can you do in an analytic application?

Question19: In a rolling forecast table, what can be used to determine the date to cut over to plan data?

Question20: You have an allocation process with 3 steps. Which of the following can be used to run only allocation step #2?

Question21: In a story, how can you create a chart to compare versions? Note: There are 2 correct Answers to this question.

Question22: When you import group reporting data from SAP S/4HANA to an SAP Analytics Cloud planning model, which mappings are required? Note: There are 2 correct Answers to this question.

Question23: You are importing from SAP S/4HANA into a planning model with pre-converted actuals turned on. What mappings are required to import both local and default currency?

Question24: You enter plan values by year and product group. You want to allocate these values to months and products in proportion to last year's actual dat a. What setting in the allocation process is required to achieve this?

Question25: How can you change plan data via the Planning Panel in a story? Note: There are 2 correct Answers to this question.

Question26: You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use? Note: There are 2 correct Answers to this question.

Question27: Which of the following are prerequisites to export transaction data to a DataStore object (advanced) in SAP Business Warehouse? Note: There are 2 correct Answers to this question.

Question28: What does SAP recommend you do to improve the performance of advanced formulas?